|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
|
Articles
|
|||||
 |
What is Data Mapping
Data mapping is a very important aspect in data integration. In fact, it is the first step in the many complex tasks associated with data integration...
|
||||
|
|||||
|
Is there a "MyISAM Hot-Backup" like the "InnoDB Hot-Backup"?
This is currently under development, and scheduled for MySQL 5.1.
|
||||
|
|||||
|
Is there any improvement in error reporting when Foreign Key fails (i.e. currently does not report which column and reference failed)?
The foreign key support in InnoDB has seen improvements in each major version of MySQL. However, global foreign key support (i.e., generically for...
|
||||
|
|||||
|
If the entire data dir is backuped daily, is restoring a database just a matter of dumping the database from tape back to the data dir?
I believe that works just fine if you are using the MyISAM storage engine, but if you are you using some of the other ones like InnoDB I believe...
|
||||
|
|||||
|
what is Maximum size of a query in mysql?
the max size would be limited by the variable max_allowed_packet
so, if you do a
show variables like 'max_allowed_packet'
it will show...
|
||||
|
|||||
|
Can MySQL 5.0 do subqueries?
Yes. MySQL supports subqueries since version 4.1 See
|
||||
|
|||||
|
Can MySQL 5.0 do multi-table inserts and updates?
Yes. Multi-table UPDATE and DELETE were actually implemented in MySQL 4.0, with enhancements added in MySQL 4.1. See and
|
||||
|
|||||
|
Does MySQL 5.0 have a Query Cache? Does it work on Server, Instance or Database?
Yes. The Query Cache was introduced in MySQL 4.0, and operates on the server level. It caches complete result sets, matched with the original query...
|
||||
|
|||||
|
Does MySQL 5.0 have a NOW() with fractions of seconds?
No. This is on the MySQL roadmap as a "rolling feature". This means that it is not a flagship feature, but will be implemented,...
|
||||
|
|||||
|
Does MySQL 5.0 work with Dual Core Opterons?
Yes. MySQL is fully multi-threaded, and will make use of multiple CPUs provided the operating system supports it.
|
||||
|
|||||
Powered by
KBPublisher (Knowledge base software)